<?php
// created: 2014-04-25 15:48:22
$searchFields['Tasks'] = array (
  'name' => 
  array (
    'query_type' => 'default',
  ),
  'contact_name' => 
  array (
    'query_type' => 'default',
    'db_field' => 
    array (
      0 => 'contacts.first_name',
      1 => 'contacts.last_name',
    ),
  ),
  'current_user_only' => 
  array (
    'query_type' => 'default',
    'db_field' => 
    array (
      0 => 'assigned_user_id',
    ),
    'my_items' => true,
    'vname' => 'LBL_CURRENT_USER_FILTER',
    'type' => 'bool',
  ),
  'assigned_user_id' => 
  array (
    'query_type' => 'default',
  ),
  'status' => 
  array (
    'query_type' => 'default',
    'options' => 'task_status_dom',
    'template_var' => 'STATUS_FILTER',
  ),
  'open_only' => 
  array (
    'query_type' => 'default',
    'db_field' => 
    array (
      0 => 'status',
    ),
    'operator' => 'not in',
    'closed_values' => 
    array (
      0 => 'Completed',
      1 => 'Deferred',
    ),
    'type' => 'bool',
  ),
  'range_date_entered' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'start_range_date_entered' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'end_range_date_entered' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'range_date_modified' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'start_range_date_modified' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'end_range_date_modified' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'range_date_start' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'start_range_date_start' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'end_range_date_start' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'range_date_due' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'start_range_date_due' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'end_range_date_due' => 
  array (
    'query_type' => 'default',
    'enable_range_search' => true,
    'is_date_field' => true,
  ),
  'job_name' => 
  array (
    'query_type' => 'default',
    'operator' => 'subquery',
    'subquery' => 'SELECT edanz_deliverables.id FROM edanz_deliverables LEFT JOIN edanz_jobs ON edanz_jobs.id = edanz_deliverables.job_id WHERE edanz_jobs.deleted=0 AND edanz_deliverables.deleted=0  AND edanz_jobs.name LIKE',
    'db_field' => 
    array (
      0 => 'deliverable_id',
    ),
  ),
  'relate_deliverable_name' => 
  array (
    'query_type' => 'default',
    'operator' => 'subquery',
    'subquery' => 'SELECT edanz_deliverables.id FROM edanz_deliverables  WHERE edanz_deliverables.deleted=0  AND edanz_deliverables.name LIKE',
    'db_field' => 
    array (
      0 => 'deliverable_id',
    ),
  ),
  'security_group' => 
  array (
    'query_type' => 'default',
    'operator' => 'customsubquery',
    'subquery' => 'SELECT securitygroups_records.record_id FROM securitygroups_records LEFT JOIN  securitygroups ON securitygroups.id=securitygroups_records.securitygroup_id where securitygroups_records.deleted=0 and securitygroups.deleted=0 and securitygroups_records.module=\'Tasks\' and securitygroups.name IN',
    'db_field' => 
    array (
      0 => 'id',
    ),
  ),
  'falgged' => 
  array (
    'query_type' => 'default',
    'operator' => 'subquerybool',
    'subquery' => 'SELECT edanz_deliverables_flags.deliverables_id FROM edanz_deliverables_flags LEFT JOIN edanz_deliverables ON edanz_deliverables.id =edanz_deliverables_flags.deliverables_id  WHERE  edanz_deliverables_flags.deleted=0 AND edanz_deliverables.deleted=0',
    'db_field' => 
    array (
      0 => 'deliverable_id',
    ),
  ),
  'deliverable_service' => 
  array (
    'query_type' => 'default',
    'operator' => 'customsubquery',
    'subquery' => 'SELECT edanz_deliverables.id FROM edanz_deliverables  WHERE edanz_deliverables.deleted=0  AND edanz_deliverables.service IN',
    'db_field' => 
    array (
      0 => 'deliverable_id',
    ),
  ),
  'speed' => 
  array (
    'query_type' => 'default',
    'operator' => 'customsubquery',
    'subquery' => 'SELECT edanz_deliverables.id FROM edanz_deliverables where edanz_deliverables.deleted = 0 and edanz_deliverables.speed IN ',
    'db_field' => 
    array (
      0 => 'deliverable_id',
    ),
  ),
);
?>
